package com.health.db.model;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class MedicalTreatRecordExample  implements Serializable{
    /**
	 * 
	 */
	private static final long serialVersionUID = -8590086678068147857L;

	protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MedicalTreatRecordExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andRecidIsNull() {
            addCriterion("RecID is null");
            return (Criteria) this;
        }

        public Criteria andRecidIsNotNull() {
            addCriterion("RecID is not null");
            return (Criteria) this;
        }

        public Criteria andRecidEqualTo(Long value) {
            addCriterion("RecID =", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotEqualTo(Long value) {
            addCriterion("RecID <>", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidGreaterThan(Long value) {
            addCriterion("RecID >", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidGreaterThanOrEqualTo(Long value) {
            addCriterion("RecID >=", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidLessThan(Long value) {
            addCriterion("RecID <", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidLessThanOrEqualTo(Long value) {
            addCriterion("RecID <=", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidIn(List<Long> values) {
            addCriterion("RecID in", values, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotIn(List<Long> values) {
            addCriterion("RecID not in", values, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidBetween(Long value1, Long value2) {
            addCriterion("RecID between", value1, value2, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotBetween(Long value1, Long value2) {
            addCriterion("RecID not between", value1, value2, "recid");
            return (Criteria) this;
        }

        public Criteria andSystemidIsNull() {
            addCriterion("systemID is null");
            return (Criteria) this;
        }

        public Criteria andSystemidIsNotNull() {
            addCriterion("systemID is not null");
            return (Criteria) this;
        }

        public Criteria andSystemidEqualTo(Integer value) {
            addCriterion("systemID =", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotEqualTo(Integer value) {
            addCriterion("systemID <>", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidGreaterThan(Integer value) {
            addCriterion("systemID >", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidGreaterThanOrEqualTo(Integer value) {
            addCriterion("systemID >=", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidLessThan(Integer value) {
            addCriterion("systemID <", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidLessThanOrEqualTo(Integer value) {
            addCriterion("systemID <=", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidIn(List<Integer> values) {
            addCriterion("systemID in", values, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotIn(List<Integer> values) {
            addCriterion("systemID not in", values, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidBetween(Integer value1, Integer value2) {
            addCriterion("systemID between", value1, value2, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotBetween(Integer value1, Integer value2) {
            addCriterion("systemID not between", value1, value2, "systemid");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidIsNull() {
            addCriterion("MedicalTreatID is null");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidIsNotNull() {
            addCriterion("MedicalTreatID is not null");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidEqualTo(Long value) {
            addCriterion("MedicalTreatID =", value, "medicaltreatid");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidNotEqualTo(Long value) {
            addCriterion("MedicalTreatID <>", value, "medicaltreatid");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidGreaterThan(Long value) {
            addCriterion("MedicalTreatID >", value, "medicaltreatid");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidGreaterThanOrEqualTo(Long value) {
            addCriterion("MedicalTreatID >=", value, "medicaltreatid");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidLessThan(Long value) {
            addCriterion("MedicalTreatID <", value, "medicaltreatid");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidLessThanOrEqualTo(Long value) {
            addCriterion("MedicalTreatID <=", value, "medicaltreatid");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidIn(List<Long> values) {
            addCriterion("MedicalTreatID in", values, "medicaltreatid");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidNotIn(List<Long> values) {
            addCriterion("MedicalTreatID not in", values, "medicaltreatid");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidBetween(Long value1, Long value2) {
            addCriterion("MedicalTreatID between", value1, value2, "medicaltreatid");
            return (Criteria) this;
        }

        public Criteria andMedicaltreatidNotBetween(Long value1, Long value2) {
            addCriterion("MedicalTreatID not between", value1, value2, "medicaltreatid");
            return (Criteria) this;
        }

        public Criteria andBillNoIsNull() {
            addCriterion("Bill_NO is null");
            return (Criteria) this;
        }

        public Criteria andBillNoIsNotNull() {
            addCriterion("Bill_NO is not null");
            return (Criteria) this;
        }

        public Criteria andBillNoEqualTo(String value) {
            addCriterion("Bill_NO =", value, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillNoNotEqualTo(String value) {
            addCriterion("Bill_NO <>", value, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillNoGreaterThan(String value) {
            addCriterion("Bill_NO >", value, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillNoGreaterThanOrEqualTo(String value) {
            addCriterion("Bill_NO >=", value, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillNoLessThan(String value) {
            addCriterion("Bill_NO <", value, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillNoLessThanOrEqualTo(String value) {
            addCriterion("Bill_NO <=", value, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillNoLike(String value) {
            addCriterion("Bill_NO like", value, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillNoNotLike(String value) {
            addCriterion("Bill_NO not like", value, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillNoIn(List<String> values) {
            addCriterion("Bill_NO in", values, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillNoNotIn(List<String> values) {
            addCriterion("Bill_NO not in", values, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillNoBetween(String value1, String value2) {
            addCriterion("Bill_NO between", value1, value2, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillNoNotBetween(String value1, String value2) {
            addCriterion("Bill_NO not between", value1, value2, "billNo");
            return (Criteria) this;
        }

        public Criteria andBillDateIsNull() {
            addCriterion("Bill_DATE is null");
            return (Criteria) this;
        }

        public Criteria andBillDateIsNotNull() {
            addCriterion("Bill_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andBillDateEqualTo(Date value) {
            addCriterion("Bill_DATE =", value, "billDate");
            return (Criteria) this;
        }

        public Criteria andBillDateNotEqualTo(Date value) {
            addCriterion("Bill_DATE <>", value, "billDate");
            return (Criteria) this;
        }

        public Criteria andBillDateGreaterThan(Date value) {
            addCriterion("Bill_DATE >", value, "billDate");
            return (Criteria) this;
        }

        public Criteria andBillDateGreaterThanOrEqualTo(Date value) {
            addCriterion("Bill_DATE >=", value, "billDate");
            return (Criteria) this;
        }

        public Criteria andBillDateLessThan(Date value) {
            addCriterion("Bill_DATE <", value, "billDate");
            return (Criteria) this;
        }

        public Criteria andBillDateLessThanOrEqualTo(Date value) {
            addCriterion("Bill_DATE <=", value, "billDate");
            return (Criteria) this;
        }

        public Criteria andBillDateIn(List<Date> values) {
            addCriterion("Bill_DATE in", values, "billDate");
            return (Criteria) this;
        }

        public Criteria andBillDateNotIn(List<Date> values) {
            addCriterion("Bill_DATE not in", values, "billDate");
            return (Criteria) this;
        }

        public Criteria andBillDateBetween(Date value1, Date value2) {
            addCriterion("Bill_DATE between", value1, value2, "billDate");
            return (Criteria) this;
        }

        public Criteria andBillDateNotBetween(Date value1, Date value2) {
            addCriterion("Bill_DATE not between", value1, value2, "billDate");
            return (Criteria) this;
        }

        public Criteria andRunFlagIsNull() {
            addCriterion("run_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andRunFlagIsNotNull() {
            addCriterion("run_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andRunFlagEqualTo(Short value) {
            addCriterion("run_FLAG =", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagNotEqualTo(Short value) {
            addCriterion("run_FLAG <>", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagGreaterThan(Short value) {
            addCriterion("run_FLAG >", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagGreaterThanOrEqualTo(Short value) {
            addCriterion("run_FLAG >=", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagLessThan(Short value) {
            addCriterion("run_FLAG <", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagLessThanOrEqualTo(Short value) {
            addCriterion("run_FLAG <=", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagIn(List<Short> values) {
            addCriterion("run_FLAG in", values, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagNotIn(List<Short> values) {
            addCriterion("run_FLAG not in", values, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagBetween(Short value1, Short value2) {
            addCriterion("run_FLAG between", value1, value2, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagNotBetween(Short value1, Short value2) {
            addCriterion("run_FLAG not between", value1, value2, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunstatusidIsNull() {
            addCriterion("runStatusID is null");
            return (Criteria) this;
        }

        public Criteria andRunstatusidIsNotNull() {
            addCriterion("runStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andRunstatusidEqualTo(Short value) {
            addCriterion("runStatusID =", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidNotEqualTo(Short value) {
            addCriterion("runStatusID <>", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidGreaterThan(Short value) {
            addCriterion("runStatusID >", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidGreaterThanOrEqualTo(Short value) {
            addCriterion("runStatusID >=", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidLessThan(Short value) {
            addCriterion("runStatusID <", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidLessThanOrEqualTo(Short value) {
            addCriterion("runStatusID <=", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidIn(List<Short> values) {
            addCriterion("runStatusID in", values, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidNotIn(List<Short> values) {
            addCriterion("runStatusID not in", values, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidBetween(Short value1, Short value2) {
            addCriterion("runStatusID between", value1, value2, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidNotBetween(Short value1, Short value2) {
            addCriterion("runStatusID not between", value1, value2, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunStatusIsNull() {
            addCriterion("run_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andRunStatusIsNotNull() {
            addCriterion("run_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andRunStatusEqualTo(String value) {
            addCriterion("run_STATUS =", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotEqualTo(String value) {
            addCriterion("run_STATUS <>", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusGreaterThan(String value) {
            addCriterion("run_STATUS >", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusGreaterThanOrEqualTo(String value) {
            addCriterion("run_STATUS >=", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusLessThan(String value) {
            addCriterion("run_STATUS <", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusLessThanOrEqualTo(String value) {
            addCriterion("run_STATUS <=", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusLike(String value) {
            addCriterion("run_STATUS like", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotLike(String value) {
            addCriterion("run_STATUS not like", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusIn(List<String> values) {
            addCriterion("run_STATUS in", values, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotIn(List<String> values) {
            addCriterion("run_STATUS not in", values, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusBetween(String value1, String value2) {
            addCriterion("run_STATUS between", value1, value2, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotBetween(String value1, String value2) {
            addCriterion("run_STATUS not between", value1, value2, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRegisteridIsNull() {
            addCriterion("RegisterID is null");
            return (Criteria) this;
        }

        public Criteria andRegisteridIsNotNull() {
            addCriterion("RegisterID is not null");
            return (Criteria) this;
        }

        public Criteria andRegisteridEqualTo(Long value) {
            addCriterion("RegisterID =", value, "registerid");
            return (Criteria) this;
        }

        public Criteria andRegisteridNotEqualTo(Long value) {
            addCriterion("RegisterID <>", value, "registerid");
            return (Criteria) this;
        }

        public Criteria andRegisteridGreaterThan(Long value) {
            addCriterion("RegisterID >", value, "registerid");
            return (Criteria) this;
        }

        public Criteria andRegisteridGreaterThanOrEqualTo(Long value) {
            addCriterion("RegisterID >=", value, "registerid");
            return (Criteria) this;
        }

        public Criteria andRegisteridLessThan(Long value) {
            addCriterion("RegisterID <", value, "registerid");
            return (Criteria) this;
        }

        public Criteria andRegisteridLessThanOrEqualTo(Long value) {
            addCriterion("RegisterID <=", value, "registerid");
            return (Criteria) this;
        }

        public Criteria andRegisteridIn(List<Long> values) {
            addCriterion("RegisterID in", values, "registerid");
            return (Criteria) this;
        }

        public Criteria andRegisteridNotIn(List<Long> values) {
            addCriterion("RegisterID not in", values, "registerid");
            return (Criteria) this;
        }

        public Criteria andRegisteridBetween(Long value1, Long value2) {
            addCriterion("RegisterID between", value1, value2, "registerid");
            return (Criteria) this;
        }

        public Criteria andRegisteridNotBetween(Long value1, Long value2) {
            addCriterion("RegisterID not between", value1, value2, "registerid");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(Long value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(Long value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(Long value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(Long value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(Long value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(Long value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<Long> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<Long> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(Long value1, Long value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(Long value1, Long value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNull() {
            addCriterion("User_NAME is null");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNotNull() {
            addCriterion("User_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andUserNameEqualTo(String value) {
            addCriterion("User_NAME =", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotEqualTo(String value) {
            addCriterion("User_NAME <>", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThan(String value) {
            addCriterion("User_NAME >", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("User_NAME >=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThan(String value) {
            addCriterion("User_NAME <", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThanOrEqualTo(String value) {
            addCriterion("User_NAME <=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLike(String value) {
            addCriterion("User_NAME like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotLike(String value) {
            addCriterion("User_NAME not like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameIn(List<String> values) {
            addCriterion("User_NAME in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotIn(List<String> values) {
            addCriterion("User_NAME not in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameBetween(String value1, String value2) {
            addCriterion("User_NAME between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotBetween(String value1, String value2) {
            addCriterion("User_NAME not between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andPatientidIsNull() {
            addCriterion("PatientID is null");
            return (Criteria) this;
        }

        public Criteria andPatientidIsNotNull() {
            addCriterion("PatientID is not null");
            return (Criteria) this;
        }

        public Criteria andPatientidEqualTo(Long value) {
            addCriterion("PatientID =", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidNotEqualTo(Long value) {
            addCriterion("PatientID <>", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidGreaterThan(Long value) {
            addCriterion("PatientID >", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidGreaterThanOrEqualTo(Long value) {
            addCriterion("PatientID >=", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidLessThan(Long value) {
            addCriterion("PatientID <", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidLessThanOrEqualTo(Long value) {
            addCriterion("PatientID <=", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidIn(List<Long> values) {
            addCriterion("PatientID in", values, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidNotIn(List<Long> values) {
            addCriterion("PatientID not in", values, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidBetween(Long value1, Long value2) {
            addCriterion("PatientID between", value1, value2, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidNotBetween(Long value1, Long value2) {
            addCriterion("PatientID not between", value1, value2, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientNameIsNull() {
            addCriterion("Patient_NAME is null");
            return (Criteria) this;
        }

        public Criteria andPatientNameIsNotNull() {
            addCriterion("Patient_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andPatientNameEqualTo(String value) {
            addCriterion("Patient_NAME =", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameNotEqualTo(String value) {
            addCriterion("Patient_NAME <>", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameGreaterThan(String value) {
            addCriterion("Patient_NAME >", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameGreaterThanOrEqualTo(String value) {
            addCriterion("Patient_NAME >=", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameLessThan(String value) {
            addCriterion("Patient_NAME <", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameLessThanOrEqualTo(String value) {
            addCriterion("Patient_NAME <=", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameLike(String value) {
            addCriterion("Patient_NAME like", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameNotLike(String value) {
            addCriterion("Patient_NAME not like", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameIn(List<String> values) {
            addCriterion("Patient_NAME in", values, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameNotIn(List<String> values) {
            addCriterion("Patient_NAME not in", values, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameBetween(String value1, String value2) {
            addCriterion("Patient_NAME between", value1, value2, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameNotBetween(String value1, String value2) {
            addCriterion("Patient_NAME not between", value1, value2, "patientName");
            return (Criteria) this;
        }

        public Criteria andHospitalidIsNull() {
            addCriterion("HospitalID is null");
            return (Criteria) this;
        }

        public Criteria andHospitalidIsNotNull() {
            addCriterion("HospitalID is not null");
            return (Criteria) this;
        }

        public Criteria andHospitalidEqualTo(Long value) {
            addCriterion("HospitalID =", value, "hospitalid");
            return (Criteria) this;
        }

        public Criteria andHospitalidNotEqualTo(Long value) {
            addCriterion("HospitalID <>", value, "hospitalid");
            return (Criteria) this;
        }

        public Criteria andHospitalidGreaterThan(Long value) {
            addCriterion("HospitalID >", value, "hospitalid");
            return (Criteria) this;
        }

        public Criteria andHospitalidGreaterThanOrEqualTo(Long value) {
            addCriterion("HospitalID >=", value, "hospitalid");
            return (Criteria) this;
        }

        public Criteria andHospitalidLessThan(Long value) {
            addCriterion("HospitalID <", value, "hospitalid");
            return (Criteria) this;
        }

        public Criteria andHospitalidLessThanOrEqualTo(Long value) {
            addCriterion("HospitalID <=", value, "hospitalid");
            return (Criteria) this;
        }

        public Criteria andHospitalidIn(List<Long> values) {
            addCriterion("HospitalID in", values, "hospitalid");
            return (Criteria) this;
        }

        public Criteria andHospitalidNotIn(List<Long> values) {
            addCriterion("HospitalID not in", values, "hospitalid");
            return (Criteria) this;
        }

        public Criteria andHospitalidBetween(Long value1, Long value2) {
            addCriterion("HospitalID between", value1, value2, "hospitalid");
            return (Criteria) this;
        }

        public Criteria andHospitalidNotBetween(Long value1, Long value2) {
            addCriterion("HospitalID not between", value1, value2, "hospitalid");
            return (Criteria) this;
        }

        public Criteria andHospitalNameIsNull() {
            addCriterion("Hospital_NAME is null");
            return (Criteria) this;
        }

        public Criteria andHospitalNameIsNotNull() {
            addCriterion("Hospital_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andHospitalNameEqualTo(String value) {
            addCriterion("Hospital_NAME =", value, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andHospitalNameNotEqualTo(String value) {
            addCriterion("Hospital_NAME <>", value, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andHospitalNameGreaterThan(String value) {
            addCriterion("Hospital_NAME >", value, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andHospitalNameGreaterThanOrEqualTo(String value) {
            addCriterion("Hospital_NAME >=", value, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andHospitalNameLessThan(String value) {
            addCriterion("Hospital_NAME <", value, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andHospitalNameLessThanOrEqualTo(String value) {
            addCriterion("Hospital_NAME <=", value, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andHospitalNameLike(String value) {
            addCriterion("Hospital_NAME like", value, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andHospitalNameNotLike(String value) {
            addCriterion("Hospital_NAME not like", value, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andHospitalNameIn(List<String> values) {
            addCriterion("Hospital_NAME in", values, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andHospitalNameNotIn(List<String> values) {
            addCriterion("Hospital_NAME not in", values, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andHospitalNameBetween(String value1, String value2) {
            addCriterion("Hospital_NAME between", value1, value2, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andHospitalNameNotBetween(String value1, String value2) {
            addCriterion("Hospital_NAME not between", value1, value2, "hospitalName");
            return (Criteria) this;
        }

        public Criteria andDepartmentidIsNull() {
            addCriterion("DepartmentID is null");
            return (Criteria) this;
        }

        public Criteria andDepartmentidIsNotNull() {
            addCriterion("DepartmentID is not null");
            return (Criteria) this;
        }

        public Criteria andDepartmentidEqualTo(Long value) {
            addCriterion("DepartmentID =", value, "departmentid");
            return (Criteria) this;
        }

        public Criteria andDepartmentidNotEqualTo(Long value) {
            addCriterion("DepartmentID <>", value, "departmentid");
            return (Criteria) this;
        }

        public Criteria andDepartmentidGreaterThan(Long value) {
            addCriterion("DepartmentID >", value, "departmentid");
            return (Criteria) this;
        }

        public Criteria andDepartmentidGreaterThanOrEqualTo(Long value) {
            addCriterion("DepartmentID >=", value, "departmentid");
            return (Criteria) this;
        }

        public Criteria andDepartmentidLessThan(Long value) {
            addCriterion("DepartmentID <", value, "departmentid");
            return (Criteria) this;
        }

        public Criteria andDepartmentidLessThanOrEqualTo(Long value) {
            addCriterion("DepartmentID <=", value, "departmentid");
            return (Criteria) this;
        }

        public Criteria andDepartmentidIn(List<Long> values) {
            addCriterion("DepartmentID in", values, "departmentid");
            return (Criteria) this;
        }

        public Criteria andDepartmentidNotIn(List<Long> values) {
            addCriterion("DepartmentID not in", values, "departmentid");
            return (Criteria) this;
        }

        public Criteria andDepartmentidBetween(Long value1, Long value2) {
            addCriterion("DepartmentID between", value1, value2, "departmentid");
            return (Criteria) this;
        }

        public Criteria andDepartmentidNotBetween(Long value1, Long value2) {
            addCriterion("DepartmentID not between", value1, value2, "departmentid");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameIsNull() {
            addCriterion("Department_NAME is null");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameIsNotNull() {
            addCriterion("Department_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameEqualTo(String value) {
            addCriterion("Department_NAME =", value, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameNotEqualTo(String value) {
            addCriterion("Department_NAME <>", value, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameGreaterThan(String value) {
            addCriterion("Department_NAME >", value, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameGreaterThanOrEqualTo(String value) {
            addCriterion("Department_NAME >=", value, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameLessThan(String value) {
            addCriterion("Department_NAME <", value, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameLessThanOrEqualTo(String value) {
            addCriterion("Department_NAME <=", value, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameLike(String value) {
            addCriterion("Department_NAME like", value, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameNotLike(String value) {
            addCriterion("Department_NAME not like", value, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameIn(List<String> values) {
            addCriterion("Department_NAME in", values, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameNotIn(List<String> values) {
            addCriterion("Department_NAME not in", values, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameBetween(String value1, String value2) {
            addCriterion("Department_NAME between", value1, value2, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDepartmentNameNotBetween(String value1, String value2) {
            addCriterion("Department_NAME not between", value1, value2, "departmentName");
            return (Criteria) this;
        }

        public Criteria andDoctoridIsNull() {
            addCriterion("DoctorID is null");
            return (Criteria) this;
        }

        public Criteria andDoctoridIsNotNull() {
            addCriterion("DoctorID is not null");
            return (Criteria) this;
        }

        public Criteria andDoctoridEqualTo(Long value) {
            addCriterion("DoctorID =", value, "doctorid");
            return (Criteria) this;
        }

        public Criteria andDoctoridNotEqualTo(Long value) {
            addCriterion("DoctorID <>", value, "doctorid");
            return (Criteria) this;
        }

        public Criteria andDoctoridGreaterThan(Long value) {
            addCriterion("DoctorID >", value, "doctorid");
            return (Criteria) this;
        }

        public Criteria andDoctoridGreaterThanOrEqualTo(Long value) {
            addCriterion("DoctorID >=", value, "doctorid");
            return (Criteria) this;
        }

        public Criteria andDoctoridLessThan(Long value) {
            addCriterion("DoctorID <", value, "doctorid");
            return (Criteria) this;
        }

        public Criteria andDoctoridLessThanOrEqualTo(Long value) {
            addCriterion("DoctorID <=", value, "doctorid");
            return (Criteria) this;
        }

        public Criteria andDoctoridIn(List<Long> values) {
            addCriterion("DoctorID in", values, "doctorid");
            return (Criteria) this;
        }

        public Criteria andDoctoridNotIn(List<Long> values) {
            addCriterion("DoctorID not in", values, "doctorid");
            return (Criteria) this;
        }

        public Criteria andDoctoridBetween(Long value1, Long value2) {
            addCriterion("DoctorID between", value1, value2, "doctorid");
            return (Criteria) this;
        }

        public Criteria andDoctoridNotBetween(Long value1, Long value2) {
            addCriterion("DoctorID not between", value1, value2, "doctorid");
            return (Criteria) this;
        }

        public Criteria andDoctorNameIsNull() {
            addCriterion("Doctor_NAME is null");
            return (Criteria) this;
        }

        public Criteria andDoctorNameIsNotNull() {
            addCriterion("Doctor_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andDoctorNameEqualTo(String value) {
            addCriterion("Doctor_NAME =", value, "doctorName");
            return (Criteria) this;
        }

        public Criteria andDoctorNameNotEqualTo(String value) {
            addCriterion("Doctor_NAME <>", value, "doctorName");
            return (Criteria) this;
        }

        public Criteria andDoctorNameGreaterThan(String value) {
            addCriterion("Doctor_NAME >", value, "doctorName");
            return (Criteria) this;
        }

        public Criteria andDoctorNameGreaterThanOrEqualTo(String value) {
            addCriterion("Doctor_NAME >=", value, "doctorName");
            return (Criteria) this;
        }

        public Criteria andDoctorNameLessThan(String value) {
            addCriterion("Doctor_NAME <", value, "doctorName");
            return (Criteria) this;
        }

        public Criteria andDoctorNameLessThanOrEqualTo(String value) {
            addCriterion("Doctor_NAME <=", value, "doctorName");
            return (Criteria) this;
        }

        public Criteria andDoctorNameLike(String value) {
            addCriterion("Doctor_NAME like", value, "doctorName");
            return (Criteria) this;
        }

        public Criteria andDoctorNameNotLike(String value) {
            addCriterion("Doctor_NAME not like", value, "doctorName");
            return (Criteria) this;
        }

        public Criteria andDoctorNameIn(List<String> values) {
            addCriterion("Doctor_NAME in", values, "doctorName");
            return (Criteria) this;
        }

        public Criteria andDoctorNameNotIn(List<String> values) {
            addCriterion("Doctor_NAME not in", values, "doctorName");
            return (Criteria) this;
        }

        public Criteria andDoctorNameBetween(String value1, String value2) {
            addCriterion("Doctor_NAME between", value1, value2, "doctorName");
            return (Criteria) this;
        }

        public Criteria andDoctorNameNotBetween(String value1, String value2) {
            addCriterion("Doctor_NAME not between", value1, value2, "doctorName");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeIsNull() {
            addCriterion("Schedule_TIME is null");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeIsNotNull() {
            addCriterion("Schedule_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeEqualTo(Date value) {
            addCriterion("Schedule_TIME =", value, "scheduleTime");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeNotEqualTo(Date value) {
            addCriterion("Schedule_TIME <>", value, "scheduleTime");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeGreaterThan(Date value) {
            addCriterion("Schedule_TIME >", value, "scheduleTime");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("Schedule_TIME >=", value, "scheduleTime");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeLessThan(Date value) {
            addCriterion("Schedule_TIME <", value, "scheduleTime");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeLessThanOrEqualTo(Date value) {
            addCriterion("Schedule_TIME <=", value, "scheduleTime");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeIn(List<Date> values) {
            addCriterion("Schedule_TIME in", values, "scheduleTime");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeNotIn(List<Date> values) {
            addCriterion("Schedule_TIME not in", values, "scheduleTime");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeBetween(Date value1, Date value2) {
            addCriterion("Schedule_TIME between", value1, value2, "scheduleTime");
            return (Criteria) this;
        }

        public Criteria andScheduleTimeNotBetween(Date value1, Date value2) {
            addCriterion("Schedule_TIME not between", value1, value2, "scheduleTime");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagIsNull() {
            addCriterion("is_treat_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagIsNotNull() {
            addCriterion("is_treat_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagEqualTo(Short value) {
            addCriterion("is_treat_FLAG =", value, "isTreatFlag");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagNotEqualTo(Short value) {
            addCriterion("is_treat_FLAG <>", value, "isTreatFlag");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagGreaterThan(Short value) {
            addCriterion("is_treat_FLAG >", value, "isTreatFlag");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagGreaterThanOrEqualTo(Short value) {
            addCriterion("is_treat_FLAG >=", value, "isTreatFlag");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagLessThan(Short value) {
            addCriterion("is_treat_FLAG <", value, "isTreatFlag");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagLessThanOrEqualTo(Short value) {
            addCriterion("is_treat_FLAG <=", value, "isTreatFlag");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagIn(List<Short> values) {
            addCriterion("is_treat_FLAG in", values, "isTreatFlag");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagNotIn(List<Short> values) {
            addCriterion("is_treat_FLAG not in", values, "isTreatFlag");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagBetween(Short value1, Short value2) {
            addCriterion("is_treat_FLAG between", value1, value2, "isTreatFlag");
            return (Criteria) this;
        }

        public Criteria andIsTreatFlagNotBetween(Short value1, Short value2) {
            addCriterion("is_treat_FLAG not between", value1, value2, "isTreatFlag");
            return (Criteria) this;
        }

        public Criteria andTreatDateIsNull() {
            addCriterion("treat_DATE is null");
            return (Criteria) this;
        }

        public Criteria andTreatDateIsNotNull() {
            addCriterion("treat_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andTreatDateEqualTo(Date value) {
            addCriterion("treat_DATE =", value, "treatDate");
            return (Criteria) this;
        }

        public Criteria andTreatDateNotEqualTo(Date value) {
            addCriterion("treat_DATE <>", value, "treatDate");
            return (Criteria) this;
        }

        public Criteria andTreatDateGreaterThan(Date value) {
            addCriterion("treat_DATE >", value, "treatDate");
            return (Criteria) this;
        }

        public Criteria andTreatDateGreaterThanOrEqualTo(Date value) {
            addCriterion("treat_DATE >=", value, "treatDate");
            return (Criteria) this;
        }

        public Criteria andTreatDateLessThan(Date value) {
            addCriterion("treat_DATE <", value, "treatDate");
            return (Criteria) this;
        }

        public Criteria andTreatDateLessThanOrEqualTo(Date value) {
            addCriterion("treat_DATE <=", value, "treatDate");
            return (Criteria) this;
        }

        public Criteria andTreatDateIn(List<Date> values) {
            addCriterion("treat_DATE in", values, "treatDate");
            return (Criteria) this;
        }

        public Criteria andTreatDateNotIn(List<Date> values) {
            addCriterion("treat_DATE not in", values, "treatDate");
            return (Criteria) this;
        }

        public Criteria andTreatDateBetween(Date value1, Date value2) {
            addCriterion("treat_DATE between", value1, value2, "treatDate");
            return (Criteria) this;
        }

        public Criteria andTreatDateNotBetween(Date value1, Date value2) {
            addCriterion("treat_DATE not between", value1, value2, "treatDate");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListIsNull() {
            addCriterion("DiseaseID_LIST is null");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListIsNotNull() {
            addCriterion("DiseaseID_LIST is not null");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListEqualTo(String value) {
            addCriterion("DiseaseID_LIST =", value, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListNotEqualTo(String value) {
            addCriterion("DiseaseID_LIST <>", value, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListGreaterThan(String value) {
            addCriterion("DiseaseID_LIST >", value, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListGreaterThanOrEqualTo(String value) {
            addCriterion("DiseaseID_LIST >=", value, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListLessThan(String value) {
            addCriterion("DiseaseID_LIST <", value, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListLessThanOrEqualTo(String value) {
            addCriterion("DiseaseID_LIST <=", value, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListLike(String value) {
            addCriterion("DiseaseID_LIST like", value, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListNotLike(String value) {
            addCriterion("DiseaseID_LIST not like", value, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListIn(List<String> values) {
            addCriterion("DiseaseID_LIST in", values, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListNotIn(List<String> values) {
            addCriterion("DiseaseID_LIST not in", values, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListBetween(String value1, String value2) {
            addCriterion("DiseaseID_LIST between", value1, value2, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andDiseaseidListNotBetween(String value1, String value2) {
            addCriterion("DiseaseID_LIST not between", value1, value2, "diseaseidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListIsNull() {
            addCriterion("illnessID_LIST is null");
            return (Criteria) this;
        }

        public Criteria andIllnessidListIsNotNull() {
            addCriterion("illnessID_LIST is not null");
            return (Criteria) this;
        }

        public Criteria andIllnessidListEqualTo(String value) {
            addCriterion("illnessID_LIST =", value, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListNotEqualTo(String value) {
            addCriterion("illnessID_LIST <>", value, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListGreaterThan(String value) {
            addCriterion("illnessID_LIST >", value, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListGreaterThanOrEqualTo(String value) {
            addCriterion("illnessID_LIST >=", value, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListLessThan(String value) {
            addCriterion("illnessID_LIST <", value, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListLessThanOrEqualTo(String value) {
            addCriterion("illnessID_LIST <=", value, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListLike(String value) {
            addCriterion("illnessID_LIST like", value, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListNotLike(String value) {
            addCriterion("illnessID_LIST not like", value, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListIn(List<String> values) {
            addCriterion("illnessID_LIST in", values, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListNotIn(List<String> values) {
            addCriterion("illnessID_LIST not in", values, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListBetween(String value1, String value2) {
            addCriterion("illnessID_LIST between", value1, value2, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andIllnessidListNotBetween(String value1, String value2) {
            addCriterion("illnessID_LIST not between", value1, value2, "illnessidList");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsIsNull() {
            addCriterion("Medical_image_URLs is null");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsIsNotNull() {
            addCriterion("Medical_image_URLs is not null");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsEqualTo(String value) {
            addCriterion("Medical_image_URLs =", value, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsNotEqualTo(String value) {
            addCriterion("Medical_image_URLs <>", value, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsGreaterThan(String value) {
            addCriterion("Medical_image_URLs >", value, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsGreaterThanOrEqualTo(String value) {
            addCriterion("Medical_image_URLs >=", value, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsLessThan(String value) {
            addCriterion("Medical_image_URLs <", value, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsLessThanOrEqualTo(String value) {
            addCriterion("Medical_image_URLs <=", value, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsLike(String value) {
            addCriterion("Medical_image_URLs like", value, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsNotLike(String value) {
            addCriterion("Medical_image_URLs not like", value, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsIn(List<String> values) {
            addCriterion("Medical_image_URLs in", values, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsNotIn(List<String> values) {
            addCriterion("Medical_image_URLs not in", values, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsBetween(String value1, String value2) {
            addCriterion("Medical_image_URLs between", value1, value2, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andMedicalImageUrlsNotBetween(String value1, String value2) {
            addCriterion("Medical_image_URLs not between", value1, value2, "medicalImageUrls");
            return (Criteria) this;
        }

        public Criteria andCommentIsNull() {
            addCriterion("comment is null");
            return (Criteria) this;
        }

        public Criteria andCommentIsNotNull() {
            addCriterion("comment is not null");
            return (Criteria) this;
        }

        public Criteria andCommentEqualTo(String value) {
            addCriterion("comment =", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotEqualTo(String value) {
            addCriterion("comment <>", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThan(String value) {
            addCriterion("comment >", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThanOrEqualTo(String value) {
            addCriterion("comment >=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThan(String value) {
            addCriterion("comment <", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThanOrEqualTo(String value) {
            addCriterion("comment <=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLike(String value) {
            addCriterion("comment like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotLike(String value) {
            addCriterion("comment not like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentIn(List<String> values) {
            addCriterion("comment in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotIn(List<String> values) {
            addCriterion("comment not in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentBetween(String value1, String value2) {
            addCriterion("comment between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotBetween(String value1, String value2) {
            addCriterion("comment not between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("create_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("create_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("create_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("create_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("create_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("create_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("create_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("create_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("create_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("create_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("update_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("update_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("update_DATE =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("update_DATE <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("update_DATE >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("update_DATE >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("update_DATE <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("update_DATE <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("update_DATE in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("update_DATE not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("update_DATE between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("update_DATE not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIsNull() {
            addCriterion("update_UserID is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIsNotNull() {
            addCriterion("update_UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridEqualTo(Long value) {
            addCriterion("update_UserID =", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotEqualTo(Long value) {
            addCriterion("update_UserID <>", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridGreaterThan(Long value) {
            addCriterion("update_UserID >", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridGreaterThanOrEqualTo(Long value) {
            addCriterion("update_UserID >=", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridLessThan(Long value) {
            addCriterion("update_UserID <", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridLessThanOrEqualTo(Long value) {
            addCriterion("update_UserID <=", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIn(List<Long> values) {
            addCriterion("update_UserID in", values, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotIn(List<Long> values) {
            addCriterion("update_UserID not in", values, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridBetween(Long value1, Long value2) {
            addCriterion("update_UserID between", value1, value2, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotBetween(Long value1, Long value2) {
            addCriterion("update_UserID not between", value1, value2, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andPatpage1IsNull() {
            addCriterion("patPage1 is null");
            return (Criteria) this;
        }

        public Criteria andPatpage1IsNotNull() {
            addCriterion("patPage1 is not null");
            return (Criteria) this;
        }

        public Criteria andPatpage1EqualTo(String value) {
            addCriterion("patPage1 =", value, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage1NotEqualTo(String value) {
            addCriterion("patPage1 <>", value, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage1GreaterThan(String value) {
            addCriterion("patPage1 >", value, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage1GreaterThanOrEqualTo(String value) {
            addCriterion("patPage1 >=", value, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage1LessThan(String value) {
            addCriterion("patPage1 <", value, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage1LessThanOrEqualTo(String value) {
            addCriterion("patPage1 <=", value, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage1Like(String value) {
            addCriterion("patPage1 like", value, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage1NotLike(String value) {
            addCriterion("patPage1 not like", value, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage1In(List<String> values) {
            addCriterion("patPage1 in", values, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage1NotIn(List<String> values) {
            addCriterion("patPage1 not in", values, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage1Between(String value1, String value2) {
            addCriterion("patPage1 between", value1, value2, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage1NotBetween(String value1, String value2) {
            addCriterion("patPage1 not between", value1, value2, "patpage1");
            return (Criteria) this;
        }

        public Criteria andPatpage2IsNull() {
            addCriterion("patPage2 is null");
            return (Criteria) this;
        }

        public Criteria andPatpage2IsNotNull() {
            addCriterion("patPage2 is not null");
            return (Criteria) this;
        }

        public Criteria andPatpage2EqualTo(String value) {
            addCriterion("patPage2 =", value, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage2NotEqualTo(String value) {
            addCriterion("patPage2 <>", value, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage2GreaterThan(String value) {
            addCriterion("patPage2 >", value, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage2GreaterThanOrEqualTo(String value) {
            addCriterion("patPage2 >=", value, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage2LessThan(String value) {
            addCriterion("patPage2 <", value, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage2LessThanOrEqualTo(String value) {
            addCriterion("patPage2 <=", value, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage2Like(String value) {
            addCriterion("patPage2 like", value, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage2NotLike(String value) {
            addCriterion("patPage2 not like", value, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage2In(List<String> values) {
            addCriterion("patPage2 in", values, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage2NotIn(List<String> values) {
            addCriterion("patPage2 not in", values, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage2Between(String value1, String value2) {
            addCriterion("patPage2 between", value1, value2, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage2NotBetween(String value1, String value2) {
            addCriterion("patPage2 not between", value1, value2, "patpage2");
            return (Criteria) this;
        }

        public Criteria andPatpage3IsNull() {
            addCriterion("patPage3 is null");
            return (Criteria) this;
        }

        public Criteria andPatpage3IsNotNull() {
            addCriterion("patPage3 is not null");
            return (Criteria) this;
        }

        public Criteria andPatpage3EqualTo(String value) {
            addCriterion("patPage3 =", value, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage3NotEqualTo(String value) {
            addCriterion("patPage3 <>", value, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage3GreaterThan(String value) {
            addCriterion("patPage3 >", value, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage3GreaterThanOrEqualTo(String value) {
            addCriterion("patPage3 >=", value, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage3LessThan(String value) {
            addCriterion("patPage3 <", value, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage3LessThanOrEqualTo(String value) {
            addCriterion("patPage3 <=", value, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage3Like(String value) {
            addCriterion("patPage3 like", value, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage3NotLike(String value) {
            addCriterion("patPage3 not like", value, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage3In(List<String> values) {
            addCriterion("patPage3 in", values, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage3NotIn(List<String> values) {
            addCriterion("patPage3 not in", values, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage3Between(String value1, String value2) {
            addCriterion("patPage3 between", value1, value2, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage3NotBetween(String value1, String value2) {
            addCriterion("patPage3 not between", value1, value2, "patpage3");
            return (Criteria) this;
        }

        public Criteria andPatpage4IsNull() {
            addCriterion("patPage4 is null");
            return (Criteria) this;
        }

        public Criteria andPatpage4IsNotNull() {
            addCriterion("patPage4 is not null");
            return (Criteria) this;
        }

        public Criteria andPatpage4EqualTo(String value) {
            addCriterion("patPage4 =", value, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage4NotEqualTo(String value) {
            addCriterion("patPage4 <>", value, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage4GreaterThan(String value) {
            addCriterion("patPage4 >", value, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage4GreaterThanOrEqualTo(String value) {
            addCriterion("patPage4 >=", value, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage4LessThan(String value) {
            addCriterion("patPage4 <", value, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage4LessThanOrEqualTo(String value) {
            addCriterion("patPage4 <=", value, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage4Like(String value) {
            addCriterion("patPage4 like", value, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage4NotLike(String value) {
            addCriterion("patPage4 not like", value, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage4In(List<String> values) {
            addCriterion("patPage4 in", values, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage4NotIn(List<String> values) {
            addCriterion("patPage4 not in", values, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage4Between(String value1, String value2) {
            addCriterion("patPage4 between", value1, value2, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage4NotBetween(String value1, String value2) {
            addCriterion("patPage4 not between", value1, value2, "patpage4");
            return (Criteria) this;
        }

        public Criteria andPatpage5IsNull() {
            addCriterion("patPage5 is null");
            return (Criteria) this;
        }

        public Criteria andPatpage5IsNotNull() {
            addCriterion("patPage5 is not null");
            return (Criteria) this;
        }

        public Criteria andPatpage5EqualTo(String value) {
            addCriterion("patPage5 =", value, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage5NotEqualTo(String value) {
            addCriterion("patPage5 <>", value, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage5GreaterThan(String value) {
            addCriterion("patPage5 >", value, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage5GreaterThanOrEqualTo(String value) {
            addCriterion("patPage5 >=", value, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage5LessThan(String value) {
            addCriterion("patPage5 <", value, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage5LessThanOrEqualTo(String value) {
            addCriterion("patPage5 <=", value, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage5Like(String value) {
            addCriterion("patPage5 like", value, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage5NotLike(String value) {
            addCriterion("patPage5 not like", value, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage5In(List<String> values) {
            addCriterion("patPage5 in", values, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage5NotIn(List<String> values) {
            addCriterion("patPage5 not in", values, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage5Between(String value1, String value2) {
            addCriterion("patPage5 between", value1, value2, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage5NotBetween(String value1, String value2) {
            addCriterion("patPage5 not between", value1, value2, "patpage5");
            return (Criteria) this;
        }

        public Criteria andPatpage6IsNull() {
            addCriterion("patPage6 is null");
            return (Criteria) this;
        }

        public Criteria andPatpage6IsNotNull() {
            addCriterion("patPage6 is not null");
            return (Criteria) this;
        }

        public Criteria andPatpage6EqualTo(String value) {
            addCriterion("patPage6 =", value, "patpage6");
            return (Criteria) this;
        }

        public Criteria andPatpage6NotEqualTo(String value) {
            addCriterion("patPage6 <>", value, "patpage6");
            return (Criteria) this;
        }

        public Criteria andPatpage6GreaterThan(String value) {
            addCriterion("patPage6 >", value, "patpage6");
            return (Criteria) this;
        }

        public Criteria andPatpage6GreaterThanOrEqualTo(String value) {
            addCriterion("patPage6 >=", value, "patpage6");
            return (Criteria) this;
        }

        public Criteria andPatpage6LessThan(String value) {
            addCriterion("patPage6 <", value, "patpage6");
            return (Criteria) this;
        }

        public Criteria andPatpage6LessThanOrEqualTo(String value) {
            addCriterion("patPage6 <=", value, "patpage6");
            return (Criteria) this;
        }

        public Criteria andPatpage6Like(String value) {
            addCriterion("patPage6 like", value, "patpage6");
            return (Criteria) this;
        }

        public Criteria andPatpage6NotLike(String value) {
            addCriterion("patPage6 not like", value, "patpage6");
            return (Criteria) this;
        }

        public Criteria andPatpage6In(List<String> values) {
            addCriterion("patPage6 in", values, "patpage6");
            return (Criteria) this;
        }

        public Criteria andPatpage6NotIn(List<String> values) {
            addCriterion("patPage6 not in", values, "patpage6");
            return (Criteria) this;
        }

        public Criteria andPatpage6Between(String value1, String value2) {
            addCriterion("patPage6 between", value1, value2, "patpage6");
            return (Criteria) this;
        }

        public Criteria andPatpage6NotBetween(String value1, String value2) {
            addCriterion("patPage6 not between", value1, value2, "patpage6");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}